// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_HR_ATTENDANCE_RECORD
// * CreateDate    : 2014-06-05 18:30:03
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:03
// * LastChanger   : 2014-06-05 18:30:03
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class HrAttendanceRecordTable : TableInfo
    {
        public const string C_TableName = "HR_ATTENDANCE_RECORD";

        public const string C_ATTENDANCE_ID = "ATTENDANCE_ID";
        public const string C_PERSON_CODE = "PERSON_CODE";
        public const string C_PERSON_NAME = "PERSON_NAME";
        public const string C_ATTENDANCE_DATE = "ATTENDANCE_DATE";
        public const string C_WEEK_DAY = "WEEK_DAY";
        public const string C_WORK_CODE = "WORK_CODE";
        public const string C_START_TIME1 = "START_TIME1";
        public const string C_END_TIME1 = "END_TIME1";
        public const string C_START_TIME2 = "START_TIME2";
        public const string C_END_TIME2 = "END_TIME2";
        public const string C_START_TIME3 = "START_TIME3";
        public const string C_END_TIME3 = "END_TIME3";
        public const string C_REMARK = "REMARK";
        public const string C_ATTENDANCE_DAY = "ATTENDANCE_DAY";
        public const string C_ABSENT_DAY = "ABSENT_DAY";
        public const string C_TRAVEL_DAY = "TRAVEL_DAY";
        public const string C_WAITING_DAY = "WAITING_DAY";
        public const string C_ATTENDANCE_HOUR = "ATTENDANCE_HOUR";
        public const string C_ABSENT_HOUR = "ABSENT_HOUR";
        public const string C_NORMAL_HOUR = "NORMAL_HOUR";
        public const string C_WEEKEND_HOUR = "WEEKEND_HOUR";
        public const string C_HOLIDAY_HOUR = "HOLIDAY_HOUR";
        public const string C_ON_DUTY_HOUR = "ON_DUTY_HOUR";
        public const string C_TRAVEL_HOUR = "TRAVEL_HOUR";
        public const string C_WAITING_HOUR = "WAITING_HOUR";
        public const string C_LATED_MINITER = "LATED_MINITER";
        public const string C_LEAVE_EARLY_MINITER = "LEAVE_EARLY_MINITER";
        public const string C_OVERTIME_COUNT = "OVERTIME_COUNT";
        public const string C_IS_APPROVED = "IS_APPROVED";
        public const string C_sourceFile = "sourceFile";

        public HrAttendanceRecordTable()
        {
            _tableName = "HR_ATTENDANCE_RECORD";
        }

        protected static HrAttendanceRecordTable _current;
        public static HrAttendanceRecordTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new HrAttendanceRecordTable();

            _current.Add(C_ATTENDANCE_ID, new ColumnInfo(C_ATTENDANCE_ID, "AttendanceId", true, typeof(string)));
            _current.Add(C_PERSON_CODE, new ColumnInfo(C_PERSON_CODE, "PersonCode", false, typeof(string)));
            _current.Add(C_PERSON_NAME, new ColumnInfo(C_PERSON_NAME, "PersonName", false, typeof(string)));
            _current.Add(C_ATTENDANCE_DATE, new ColumnInfo(C_ATTENDANCE_DATE, "AttendanceDate", false, typeof(DateTime)));
            _current.Add(C_WEEK_DAY, new ColumnInfo(C_WEEK_DAY, "WeekDay", false, typeof(string)));
            _current.Add(C_WORK_CODE, new ColumnInfo(C_WORK_CODE, "WorkCode", false, typeof(string)));
            _current.Add(C_START_TIME1, new ColumnInfo(C_START_TIME1, "StartTime1", false, typeof(string)));
            _current.Add(C_END_TIME1, new ColumnInfo(C_END_TIME1, "EndTime1", false, typeof(string)));
            _current.Add(C_START_TIME2, new ColumnInfo(C_START_TIME2, "StartTime2", false, typeof(string)));
            _current.Add(C_END_TIME2, new ColumnInfo(C_END_TIME2, "EndTime2", false, typeof(string)));
            _current.Add(C_START_TIME3, new ColumnInfo(C_START_TIME3, "StartTime3", false, typeof(string)));
            _current.Add(C_END_TIME3, new ColumnInfo(C_END_TIME3, "EndTime3", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK, "Remark", false, typeof(string)));
            _current.Add(C_ATTENDANCE_DAY, new ColumnInfo(C_ATTENDANCE_DAY, "AttendanceDay", false, typeof(decimal)));
            _current.Add(C_ABSENT_DAY, new ColumnInfo(C_ABSENT_DAY, "AbsentDay", false, typeof(decimal)));
            _current.Add(C_TRAVEL_DAY, new ColumnInfo(C_TRAVEL_DAY, "TravelDay", false, typeof(decimal)));
            _current.Add(C_WAITING_DAY, new ColumnInfo(C_WAITING_DAY, "WaitingDay", false, typeof(decimal)));
            _current.Add(C_ATTENDANCE_HOUR, new ColumnInfo(C_ATTENDANCE_HOUR, "AttendanceHour", false, typeof(decimal)));
            _current.Add(C_ABSENT_HOUR, new ColumnInfo(C_ABSENT_HOUR, "AbsentHour", false, typeof(decimal)));
            _current.Add(C_NORMAL_HOUR, new ColumnInfo(C_NORMAL_HOUR, "NormalHour", false, typeof(decimal)));
            _current.Add(C_WEEKEND_HOUR, new ColumnInfo(C_WEEKEND_HOUR, "WeekendHour", false, typeof(decimal)));
            _current.Add(C_HOLIDAY_HOUR, new ColumnInfo(C_HOLIDAY_HOUR, "HolidayHour", false, typeof(decimal)));
            _current.Add(C_ON_DUTY_HOUR, new ColumnInfo(C_ON_DUTY_HOUR, "OnDutyHour", false, typeof(decimal)));
            _current.Add(C_TRAVEL_HOUR, new ColumnInfo(C_TRAVEL_HOUR, "TravelHour", false, typeof(decimal)));
            _current.Add(C_WAITING_HOUR, new ColumnInfo(C_WAITING_HOUR, "WaitingHour", false, typeof(decimal)));
            _current.Add(C_LATED_MINITER, new ColumnInfo(C_LATED_MINITER, "LatedMiniter", false, typeof(decimal)));
            _current.Add(C_LEAVE_EARLY_MINITER, new ColumnInfo(C_LEAVE_EARLY_MINITER, "LeaveEarlyMiniter", false, typeof(decimal)));
            _current.Add(C_OVERTIME_COUNT, new ColumnInfo(C_OVERTIME_COUNT, "OvertimeCount", false, typeof(decimal)));
            _current.Add(C_IS_APPROVED, new ColumnInfo(C_IS_APPROVED, "IsApproved", false, typeof(string)));
            _current.Add(C_sourceFile, new ColumnInfo(C_sourceFile, "Sourcefile", false, typeof(string)));

        }

        public ColumnInfo ATTENDANCE_ID
        {
            get { return this[C_ATTENDANCE_ID]; }
        }

        public ColumnInfo PERSON_CODE
        {
            get { return this[C_PERSON_CODE]; }
        }

        public ColumnInfo PERSON_NAME
        {
            get { return this[C_PERSON_NAME]; }
        }

        public ColumnInfo ATTENDANCE_DATE
        {
            get { return this[C_ATTENDANCE_DATE]; }
        }

        public ColumnInfo WEEK_DAY
        {
            get { return this[C_WEEK_DAY]; }
        }

        public ColumnInfo WORK_CODE
        {
            get { return this[C_WORK_CODE]; }
        }

        public ColumnInfo START_TIME1
        {
            get { return this[C_START_TIME1]; }
        }

        public ColumnInfo END_TIME1
        {
            get { return this[C_END_TIME1]; }
        }

        public ColumnInfo START_TIME2
        {
            get { return this[C_START_TIME2]; }
        }

        public ColumnInfo END_TIME2
        {
            get { return this[C_END_TIME2]; }
        }

        public ColumnInfo START_TIME3
        {
            get { return this[C_START_TIME3]; }
        }

        public ColumnInfo END_TIME3
        {
            get { return this[C_END_TIME3]; }
        }

        public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }

        public ColumnInfo ATTENDANCE_DAY
        {
            get { return this[C_ATTENDANCE_DAY]; }
        }

        public ColumnInfo ABSENT_DAY
        {
            get { return this[C_ABSENT_DAY]; }
        }

        public ColumnInfo TRAVEL_DAY
        {
            get { return this[C_TRAVEL_DAY]; }
        }

        public ColumnInfo WAITING_DAY
        {
            get { return this[C_WAITING_DAY]; }
        }

        public ColumnInfo ATTENDANCE_HOUR
        {
            get { return this[C_ATTENDANCE_HOUR]; }
        }

        public ColumnInfo ABSENT_HOUR
        {
            get { return this[C_ABSENT_HOUR]; }
        }

        public ColumnInfo NORMAL_HOUR
        {
            get { return this[C_NORMAL_HOUR]; }
        }

        public ColumnInfo WEEKEND_HOUR
        {
            get { return this[C_WEEKEND_HOUR]; }
        }

        public ColumnInfo HOLIDAY_HOUR
        {
            get { return this[C_HOLIDAY_HOUR]; }
        }

        public ColumnInfo ON_DUTY_HOUR
        {
            get { return this[C_ON_DUTY_HOUR]; }
        }

        public ColumnInfo TRAVEL_HOUR
        {
            get { return this[C_TRAVEL_HOUR]; }
        }

        public ColumnInfo WAITING_HOUR
        {
            get { return this[C_WAITING_HOUR]; }
        }

        public ColumnInfo LATED_MINITER
        {
            get { return this[C_LATED_MINITER]; }
        }

        public ColumnInfo LEAVE_EARLY_MINITER
        {
            get { return this[C_LEAVE_EARLY_MINITER]; }
        }

        public ColumnInfo OVERTIME_COUNT
        {
            get { return this[C_OVERTIME_COUNT]; }
        }

        public ColumnInfo IS_APPROVED
        {
            get { return this[C_IS_APPROVED]; }
        }

        public ColumnInfo sourceFile
        {
            get { return this[C_sourceFile]; }
        }



    }
}

